KS_BASE_PRICES

Ordinal

Description

Data
Type

Data
Length

Required

Check
Constraints

Comments

1

Item ID

string

25

Y

 

 

2

Price Sheet Code

string

30

 

 

This field is used to identify a unique price sheet. Customer locations are associated to a default price sheet in the storefront so base pricing can be determined. If this is left blank, then the overall Price Sheet for the store is used or Price Matrices may explicitly set the Price Sheet to use. Examples: USA, STOREnn, BRANCHnn

3

Base Price

money

 

Y

 

This is the base price for this item and price list. The storefront starts with this number then applies any markups or discounts defined. This is also referred to as list price.

4

Price Basis Code

string

30

 

 

This field is a secondary filter to Price Sheet to determine customer specific pricing. Examples: LIST, MSRP, WHOLESALE, RETAIL, COST)

5

Start Date

date

 

 

Must be a proper date

Defines when this price will be in effect. Can be left blank which means effective now until a future date is reached that activates a new price entry.